CREATE PROCEDURE [dbo].[sp_asi_UpdateCompanySort]
AS
    BEGIN

        SET NOCOUNT ON

        SET ROWCOUNT 1000
        DECLARE @isDone BIT
        SET @isDone = 0
        WHILE ( @isDone = 0 )
            BEGIN
                BEGIN TRANSACTION
                UPDATE  Name
                SET     COMPANY_SORT = dbo.fn_asi_GetCompanySort(COMPANY)
                WHERE   ( COMPANY_SORT <> dbo.fn_asi_GetCompanySort(COMPANY) )
                        AND ( LEN(COMPANY_SORT) = 0 )
                IF @@ROWCOUNT = 0
                    SET @isDone = 1
                COMMIT TRANSACTION
            END
        SET ROWCOUNT 0
    END


GO
GRANT EXECUTE ON  [dbo].[sp_asi_UpdateCompanySort] TO [IMIS]
GO